2013-09-04 - 8771 - Break Fix - BI-repeat group header in BPC200 #CrystalReportsSupport
BREAK FIX
8771 - BI - repeat group header in BPC200
Problem Summary
Need to fix group header that isn't repeating in BPC200.
Admin Info
Purpose
|
Group header isn't repeating in BPC200
|
Requested By
|
Sheila Halloran
|
Issue Date
|
09/04/2013
|
Resolved by
|
Mallareddy D
|
Resolved Date
|
09/04/2013
|
Document Status
|
Complete
|
Detailed Problem Description
Chat with Kevin :
Requirement 1:
1. BPC200 having a Customer text field, It is displaying correctly in Crystal Report Designer.
2. When we Schedule the report in BI LauchPad, Customer Name overlaps with one of the Revenue fields.
Requirement 2:
1. BPC200 has multiple group headers for one grouping in that it has three subreports for the grouping of Region.
2. Want to show the Region name on every page.
3. It contains three subreports per grouping and the Customer subreport which is the last seems to be going to the next page.
Requirement 3:
1. Sales Org name in Group 3 is not showing in each page.
2. On the fourth page when it goes to Customer, the Sales Org does not show at the top.
Requirement 4:
1. Combine all the parameters, so there is only one set of parameters.
Solution Analysis and Recommendations
1. BPC200 report containing Four groups and Second Group and Fourth Group are divided to Four sub group headers.
2. In each Sub group header we placed Four sub reports.
3. We are showing the Group Name in Group Header1.
4. When the sub reports are exceeded to one page then the Group Name is not displaying on the top of the report.
5 We are showing Group 2 title in each page, here also we are facing the same problem.
6. We need to show show the respective group header/title in each page.
7. We need to link the Main report parameters with respective sub reports parameters to show one set of parameters.
8. We need to apply Can grow option on the Customer text field.
Test Plan
SNo.
|
Test Scenario
|
Expected Results
|
1.
|
Report Format
|
As per NEC standards
|
2.
|
Execute Crystal Report in Crystal Designer tool after changes
|
Report should execute successfully in Crystal Designer tool
|
3.
|
Scheduling the Report in NEC BI Launch Pad
|
Report should execute successfully in NEC BI Launch Pad
|
Resolution
Resolution 1:
1. Need to apply Can Grow option for the Customer field to avoid the Overlap on to the Revenue fields.
2. Need to set the No.of lines box right to 1.
Resolution 2:
1. We need to create a group header1 and need to set Repeat Group Header on each page in group header2 also.
2. We need to create two formulas for assigning and resetting the value for a variable.
3. Need to use the above formulas to show/hide the Group Header1 i.e., Region name in each page.
Resolution 3:
1. For repeating Sales Org name, need to create a Group and need to place the Sales Org name on the newly created group header.
2. Need to use the above created assign/reset formulas to show/hide the Sales Org name on the respective pages.
3. We need to check the Repeat Page header for each group for New group header.
4. We need to apply New Page Before/New Page After options for respective Groups.
Resolution 4:
1. We need to link the Main report's parameters with all Sub reports respective Parameters.
Release Information
None